package com.tbm.console.proj.repository;

import com.tbm.console.base.repository.CommonRepository;
import com.tbm.console.proj.entity.ColumnEntity;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface ColumnRepository extends CommonRepository<ColumnEntity> {

    @Query(value=" SELECT t.TABLE_NAME FROM information_schema.TABLES t where t.TABLE_TYPE='BASE TABLE' and t.TABLE_SCHEMA='console' and t.TABLE_NAME like 'ta_%'",nativeQuery = true)
    List<String> findAllTables();

}
